AdIPEDSDistEdCriteriaDetail

EntityType | Independent
Logical Entity Name | AdIPEDSDistEdCriteriaDetail
Default Table Name | AdIPEDSDistEdCriteriaDetail
Logical Only | NO
Owner | dbo
Definition |
Note |

AdIPEDSDistEdCriteriaDetail Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
AdIPEDSDistEdCriteriaDetailId |  | CHAR(10) | NO |
AdIPEDSDistEdCriteriaID |  | CHAR(10) | NO |
EnrollCampusID |  | INTEGER | YES |
CourseRegCampusID |  | INTEGER | YES |
DeliveryMethodId |  | INTEGER | YES |
CourseTypeId |  | INTEGER | YES |
EnrollShiftID |  | INTEGER | YES |
CourseShiftID |  | INTEGER | YES |
ProgramId |  | INTEGER | YES |
ProgramVersionId |  | INTEGER | YES |
ExtraCurricularActivityId |  | INTEGER | YES |
UserId |  | INTEGER | NO |
DateAdded |  | CHAR(10) | NO |
DateLstMod |  | CHAR(10) | NO |
ts |  | CHAR(10) | NO |

AdIPEDSDistEdCriteriaDetail Keys

Key Name | Key Type | Keys
Pk_AdIPEDSDistEdCriteriaDetail_AdIPEDSDistEdCriteriaDetailId | PrimaryKey | AdIPEDSDistEdCriteriaDetailId
NK_AdIPEDSDistEdCriteriaDetail_AdIPEDSDistEdCriteriaID | Inversion Entry | AdIPEDSDistEdCriteriaID
NK_AdIPEDSDistEdCriteriaDetail_EnrollCampusID | Inversion Entry | EnrollCampusID
NK_AdIPEDSDistEdCriteriaDetail_CourseRegCampusID | Inversion Entry | CourseRegCampusID
NK_AdIPEDSDistEdCriteriaDetail_AdDeliveryMethodID | Inversion Entry | DeliveryMethodId
NK_AdIPEDSDistEdCriteriaDetail_AdCourseTypeID | Inversion Entry | CourseTypeId
NK_AdIPEDSDistEdCriteriaDetail_EnrollShiftID | Inversion Entry | EnrollShiftID
NK_AdIPEDSDistEdCriteriaDetail_CourseShiftID | Inversion Entry | CourseShiftID
NK_AdIPEDSDistEdCriteriaDetail_AdProgramID | Inversion Entry | ProgramId
NK_AdIPEDSDistEdCriteriaDetail_AdProgramVersionID | Inversion Entry | ProgramVersionId
NK_AdIPEDSDistEdCriteriaDetail_AmExtraCurrID | Inversion Entry | ExtraCurricularActivityId

AdIPEDSDistEdCriteriaDetail Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
CourseType | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseTypeId | NO
DeliveryMethod | Non-Identifying | Zero or One to Zero or More |  |  |  | DeliveryMethodId | NO
AdIPEDSDistEdCriteria | Non-Identifying | One To Zero or More |  |  |  | AdIPEDSDistEdCriteriaID | NO
Program | Non-Identifying | Zero or One to Zero or More |  |  |  | ProgramId | NO
ProgramVersion | Non-Identifying | Zero or One to Zero or More |  |  |  | ProgramVersionId | NO
ExtraCurricularActivity | Non-Identifying | Zero or One to Zero or More |  |  |  | ExtraCurricularActivityId | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseRegCampusID | NO
Shift | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseShiftID | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | EnrollCampusID | NO
Shift | Non-Identifying | Zero or One to Zero or More |  |  |  | EnrollShiftID | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | UserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

AdIPEDSDistEdCriteriaDetail Check Constraints

Check Constraint Name | CheckConstraint

AdIPEDSDistEdCriteriaDetail Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.AdIPEDSDistEdCriteriaDetail | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdIPEDSDistEdCriteriaDetail | NO |  |  |

AdIPEDSDistEdCriteriaDetail Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model

AdIPEDSDistEdCriteriaDetail Data Movement Rules

Name | Type | Rule Text/Value